Note: This statement is named Previous Recordset Row in the Add Statement dialog box.
Moves to the previous row in a recordset. If the recordset row index is at RecordsetBOF, the index does not change.
Syntax
PrevRow(Recordset)
Arguments
Argument | Description |
---|---|
Recordset | Recordset name. Must be opened with OpenRecordset or OpenRecordsetQuery. |
Example
rs = OpenRecordset("WysiCorp Bugs (Excel)")
LastRow(rs)
While Not RecordsetBOF(rs)
PrintLn(GetRowValue(rs, "First Name"))
PrevRow(rs)
WEnd